package goomi.staticPage;

import java.util.ArrayList;
import db.mysql.mySqlUtils;

public class staticPageService {
	public static void main(String args[]) 
	{
		//test
		try{
			staticPageService a = new staticPageService();
			System.out.println(a.getStaticPage("1"));
		}catch(Exception ex)
		{
			ex.printStackTrace();
		}
	}

	
	public ArrayList getStaticPage(String id){

		String sql = "select * from static_page ";
		if(id != null && !"all".equals(id)){
			sql += " where id = '" + id + "' ";
		}
		
		return mySqlUtils.Query(sql);
	}
}
